Tabela PerfServiceConfirmation

Definicja tabeli PerfServiceConfirmation

Name

PerfServiceConfirmation

Code

PerfServiceConfirmation

Comment

Potwierdzenia dla zlecen (w tym przypadku podan leków)


Lista kolumn tabeli PerfServiceConfirmation

Name

Code

PerfServiceConfirmationID

PerfServiceConfirmationID

PerfServiceConfirmTypeID

PerfServiceConfirmTypeID

PerfServiceID

PerfServiceID

EventID

EventID

Confirmed

Confirmed

ConfirmDT

ConfirmDT

ConfirmPersonID

ConfirmPersonID

Comments

Comments

Active

Active


Kolumna PerfServiceConfirmationID tabeli PerfServiceConfirmation

Definicja kolumny PerfServiceConfirmationID tabeli PerfServiceConfirmation

Name

PerfServiceConfirmationID

Code

PerfServiceConfirmationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID potwierdzenia zlecenia


Kolumna PerfServiceConfirmTypeID tabeli PerfServiceConfirmation

Definicja kolumny PerfServiceConfirmTypeID tabeli PerfServiceConfirmation

Name

PerfServiceConfirmTypeID

Code

PerfServiceConfirmTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu potwierdzenia


Kolumna PerfServiceID tabeli PerfServiceConfirmation

Definicja kolumny PerfServiceID tabeli PerfServiceConfirmation

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zlecenia/uslugi


Kolumna EventID tabeli PerfServiceConfirmation

Definicja kolumny EventID tabeli PerfServiceConfirmation

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zdarzenia


Kolumna Confirmed tabeli PerfServiceConfirmation

Definicja kolumny Confirmed tabeli PerfServiceConfirmation

Name

Confirmed

Code

Confirmed

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga oznaczajaca potwierdzenie zlecenia


Kolumna ConfirmDT tabeli PerfServiceConfirmation

Definicja kolumny ConfirmDT tabeli PerfServiceConfirmation

Name

ConfirmDT

Code

ConfirmDT

Data Type

DATE

Mandatory

No

Comment

Data potwierdzenia


Kolumna ConfirmPersonID tabeli PerfServiceConfirmation

Definicja kolumny ConfirmPersonID tabeli PerfServiceConfirmation

Name

ConfirmPersonID

Code

ConfirmPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Osoba potwierdzajaca


Kolumna Comments tabeli PerfServiceConfirmation

Definicja kolumny Comments tabeli PerfServiceConfirmation

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz


Kolumna Active tabeli PerfServiceConfirmation

Definicja kolumny Active tabeli PerfServiceConfirmation

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

Aktywnosc potwierdzenia


Lista kluczy tabeli PerfServiceConfirmation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfServiceConfirmation

Definicja klucza Identifier_1 tabeli PerfServiceConfirmation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment